Open Source Visual Basic for Applications (VBA) CSV Software

This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail Contacts), Apple IOS, Samsung Android devices and other platforms. If this doesn't work for you, please email me the VCF file and I'll modify the code to support your specific VCF format. To use, simply download and open the Excel file (xlsm), Enable Macros if prompted, and then select the VCF file you wish to import. Once complete, Excel will create and save new file titled VCFExport.csv that can also be saved in Excel format.

You have been struggling with SPSS databases when you needed to use excel? Well, this file (or the VBA module attached to it) will help you: you paste your CVS file format into one sheet, and the bulky strings will all your values will gently be split into one value per column by a custom excel function, The function takes into account that some values might be strings with comas that should not be split into different variables. The custom function should be usable for other types of files, it basically disaggregare a string into values separated by a standard character (by default the coma, but can be changed) and ignores separation characters that are within "string identifier" characters (by default the " ). It is a very simple excel file, you need to allow the macros to use it.

The London Datastore (http://data.london.gov.uk) was created by the Greater London Authority (GLA) as an innovation towards freeing London’s data. This SourceForge Project will be used to Open Source our development efforts surrounding data formats